<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" >
<sqlMap namespace="com.uc.training.smadmin.gds.dao.CommentPicDao">
    <!--获取评论列表-->
    <select id="getCommentPicByCommentId" parameterClass="Long"  resultClass="com.uc.training.smadmin.gds.re.CommentPicRE">
        select
          id,
          image_url AS imageUrl
        from t_gds_comment_pic
        WHERE  comment_id = #commentId#
        order by create_time ASC
    </select>
</sqlMap>